import pandas as pd
import numpy as np
my_list=['算法','软件','前端','人工智能','Android','Java','安卓','运维','图像','数据']
input_file="./data4_3_classify_job/salary_execl.xlsx"
data1=pd.read_excel(input_file)
data1=data1.values
for l in my_list:
    output_file=f"./data4_3_classify_job/{l}.xlsx"
    job_name=[]
    company_name=[]
    salary=[]
    address=[]
    education_requirements=[]
    for item in data1:
        if l in item[0]:
            job_name.append(item[0])
            company_name.append(item[1])
            salary.append(item[2])
            address.append(item[3])
            education_requirements.append(item[4])
    data2={"job_name":job_name,
           "company_name":company_name,
           "salary":salary,
           "address":address,
           "education_requirements":education_requirements}
    data2=pd.DataFrame(data2)
    data2.to_excel(output_file)